Pandas Profiling Report

Dataset statistics

Number of variables	13
Number of observations	170089
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	16.9 MiB
Average record size in memory	104.0 B

Variable types

Numeric	11
Categorical	2

Alerts

`uri` has a high cardinality: 170089 distinct values	High cardinality
`energy` is highly overall correlated with `loudness` and 1 other fields	High correlation
`loudness` is highly overall correlated with `energy` and 1 other fields	High correlation
`acousticness` is highly overall correlated with `energy` and 1 other fields	High correlation
`uri` is uniformly distributed	Uniform
`uri` has unique values	Unique
`key` has 20373 (12.0%) zeros	Zeros
`instrumentalness` has 58312 (34.3%) zeros	Zeros

Reproduction

Analysis started	2023-04-30 18:14:58.602352
Analysis finished	2023-04-30 18:15:13.846899
Duration	15.24 seconds
Software version	ydata-profiling v0.0.dev0
Download configuration	config.json

danceability
Real number (ℝ)

Distinct	1203
Distinct (%)	0.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.56977831

Minimum	0
Maximum	0.991
Zeros	97
Zeros (%)	0.1%
Negative	0
Negative (%)	0.0%
Memory size	1.3 MiB

Quantile statistics

Minimum	0
5-th percentile	0.261
Q1	0.458
median	0.581
Q3	0.695
95-th percentile	0.8326
Maximum	0.991
Range	0.991
Interquartile range (IQR)	0.237

Descriptive statistics

Standard deviation	0.1717207
Coefficient of variation (CV)	0.3013816
Kurtosis	-0.23993926
Mean	0.56977831
Median Absolute Deviation (MAD)	0.118
Skewness	-0.33197851
Sum	96913.023
Variance	0.029487998
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.608	439	0.3%
0.573	433	0.3%
0.606	428	0.3%
0.571	422	0.2%
0.603	421	0.2%
0.565	420	0.2%
0.607	413	0.2%
0.564	412	0.2%
0.581	411	0.2%
0.559	408	0.2%
Other values (1193)	165882	97.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	97	0.1%
0.0567	1	< 0.1%
0.0568	2	< 0.1%
0.0573	2	< 0.1%
0.0591	1	< 0.1%
0.0596	1	< 0.1%
0.0598	1	< 0.1%
0.0599	1	< 0.1%
0.0601	1	< 0.1%
0.0602	1	< 0.1%

Value	Count	Frequency (%)
0.991	1	< 0.1%
0.988	1	< 0.1%
0.986	1	< 0.1%
0.985	1	< 0.1%
0.984	4	< 0.1%
0.983	2	< 0.1%
0.982	4	< 0.1%
0.981	3	< 0.1%
0.98	4	< 0.1%
0.979	2	< 0.1%

energy
Real number (ℝ)

Distinct	2124
Distinct (%)	1.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.62201827

Minimum	0
Maximum	1
Zeros	21
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	1.3 MiB

Quantile statistics

Minimum	0
5-th percentile	0.158
Q1	0.459
median	0.66
Q3	0.82
95-th percentile	0.949
Maximum	1
Range	1
Interquartile range (IQR)	0.361

Descriptive statistics

Standard deviation	0.24179157
Coefficient of variation (CV)	0.38872102
Kurtosis	-0.53050464
Mean	0.62201827
Median Absolute Deviation (MAD)	0.176
Skewness	-0.5505159
Sum	105798.47
Variance	0.058463166
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.869	321	0.2%
0.794	318	0.2%
0.716	318	0.2%
0.855	317	0.2%
0.728	315	0.2%
0.721	315	0.2%
0.727	313	0.2%
0.837	308	0.2%
0.867	306	0.2%
0.717	306	0.2%
Other values (2114)	166952	98.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	21	< 0.1%
2 × 10^-5	1	< 0.1%
2.02 × 10^-5	2	< 0.1%
2.03 × 10^-5	1	< 0.1%
2.05 × 10^-5	1	< 0.1%
4.87 × 10^-5	1	< 0.1%
5.62 × 10^-5	1	< 0.1%
6.9 × 10^-5	1	< 0.1%
7.08 × 10^-5	1	< 0.1%
9.84 × 10^-5	1	< 0.1%

Value	Count	Frequency (%)
1	8	< 0.1%
0.999	19	< 0.1%
0.998	60	< 0.1%
0.997	57	< 0.1%
0.996	84	< 0.1%
0.995	101	0.1%
0.994	112	0.1%
0.993	135	0.1%
0.992	102	0.1%
0.991	119	0.1%

key
Real number (ℝ)

Distinct	12
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	5.2605812

Minimum	0
Maximum	11
Zeros	20373
Zeros (%)	12.0%
Negative	0
Negative (%)	0.0%
Memory size	1.3 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	2
median	5
Q3	8
95-th percentile	11
Maximum	11
Range	11
Interquartile range (IQR)	6

Descriptive statistics

Standard deviation	3.5777138
Coefficient of variation (CV)	0.68009857
Kurtosis	-1.295705
Mean	5.2605812
Median Absolute Deviation (MAD)	3
Skewness	0.0018090546
Sum	894767
Variance	12.800036
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=12)

Value	Count	Frequency (%)
0	20373	12.0%
7	19728	11.6%
2	17529	10.3%
9	17213	10.1%
1	16449	9.7%
5	13840	8.1%
11	13463	7.9%
4	12813	7.5%
6	11230	6.6%
8	11033	6.5%
Other values (2)	16418	9.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	20373	12.0%
1	16449	9.7%
2	17529	10.3%
3	5446	3.2%
4	12813	7.5%
5	13840	8.1%
6	11230	6.6%
7	19728	11.6%
8	11033	6.5%
9	17213	10.1%

Value	Count	Frequency (%)
11	13463	7.9%
10	10972	6.5%
9	17213	10.1%
8	11033	6.5%
7	19728	11.6%
6	11230	6.6%
5	13840	8.1%
4	12813	7.5%
3	5446	3.2%
2	17529	10.3%

loudness
Real number (ℝ)

Distinct	21575
Distinct (%)	12.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	-8.2187895

Minimum	-60
Maximum	2.766
Zeros	0
Zeros (%)	0.0%
Negative	170030
Negative (%)	> 99.9%
Memory size	1.3 MiB

Quantile statistics

Minimum	-60
5-th percentile	-17.101
Q1	-9.955
median	-7.064
Q3	-5.186
95-th percentile	-3.266
Maximum	2.766
Range	62.766
Interquartile range (IQR)	4.769

Descriptive statistics

Standard deviation	4.6157496
Coefficient of variation (CV)	-0.56160942
Kurtosis	6.565149
Mean	-8.2187895
Median Absolute Deviation (MAD)	2.211
Skewness	-1.9799435
Sum	-1397925.7
Variance	21.305144
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
-5.682	40	< 0.1%
-5.385	40	< 0.1%
-5.772	39	< 0.1%
-5.603	39	< 0.1%
-4.683	38	< 0.1%
-5.804	38	< 0.1%
-5.296	38	< 0.1%
-5.526	38	< 0.1%
-6.324	38	< 0.1%
-6.018	37	< 0.1%
Other values (21565)	169704	99.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-60	12	< 0.1%
-47.885	1	< 0.1%
-47.669	1	< 0.1%
-47.042	1	< 0.1%
-46.839	1	< 0.1%
-45.545	1	< 0.1%
-44.749	1	< 0.1%
-44.556	1	< 0.1%
-44.15	1	< 0.1%
-43.886	1	< 0.1%

Value	Count	Frequency (%)
2.766	1	< 0.1%
2.745	1	< 0.1%
2.625	1	< 0.1%
2.594	1	< 0.1%
2.574	1	< 0.1%
2.353	1	< 0.1%
2.238	1	< 0.1%
2.172	1	< 0.1%
2.127	1	< 0.1%
2	1	< 0.1%

mode
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.3 MiB

1	112556
0	57533

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	170089
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	0
5th row	1

Common Values

Value	Count	Frequency (%)
1	112556	66.2%
0	57533	33.8%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
1	112556	66.2%
0	57533	33.8%

Most occurring characters

Value	Count	Frequency (%)
1	112556	66.2%
0	57533	33.8%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	170089	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
1	112556	66.2%
0	57533	33.8%

Most occurring scripts

Value	Count	Frequency (%)
Common	170089	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
1	112556	66.2%
0	57533	33.8%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	170089	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
1	112556	66.2%
0	57533	33.8%

speechiness
Real number (ℝ)

Distinct	1563
Distinct (%)	0.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.087511503

Minimum	0
Maximum	0.963
Zeros	97
Zeros (%)	0.1%
Negative	0
Negative (%)	0.0%
Memory size	1.3 MiB

Quantile statistics

Minimum	0
5-th percentile	0.0279
Q1	0.0348
median	0.0473
Q3	0.0889
95-th percentile	0.306
Maximum	0.963
Range	0.963
Interquartile range (IQR)	0.0541

Descriptive statistics

Standard deviation	0.099464025
Coefficient of variation (CV)	1.1365823
Kurtosis	14.489718
Mean	0.087511503
Median Absolute Deviation (MAD)	0.016
Skewness	3.2024646
Sum	14884.744
Variance	0.0098930923
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.0328	561	0.3%
0.032	558	0.3%
0.0332	546	0.3%
0.031	545	0.3%
0.0326	544	0.3%
0.0312	538	0.3%
0.0316	533	0.3%
0.0308	531	0.3%
0.0322	529	0.3%
0.0318	528	0.3%
Other values (1553)	164676	96.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	97	0.1%
0.0219	1	< 0.1%
0.0222	2	< 0.1%
0.0223	2	< 0.1%
0.0224	6	< 0.1%
0.0225	7	< 0.1%
0.0226	6	< 0.1%
0.0227	8	< 0.1%
0.0228	15	< 0.1%
0.0229	8	< 0.1%

Value	Count	Frequency (%)
0.963	1	< 0.1%
0.962	3	< 0.1%
0.961	3	< 0.1%
0.96	2	< 0.1%
0.959	1	< 0.1%
0.958	3	< 0.1%
0.956	2	< 0.1%
0.955	2	< 0.1%
0.954	6	< 0.1%
0.953	4	< 0.1%

acousticness
Real number (ℝ)

Distinct	4910
Distinct (%)	2.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.28731746

Minimum	0
Maximum	0.996
Zeros	25
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	1.3 MiB

Quantile statistics

Minimum	0
5-th percentile	0.000384
Q1	0.019
median	0.141
Q3	0.513
95-th percentile	0.931
Maximum	0.996
Range	0.996
Interquartile range (IQR)	0.494

Descriptive statistics

Standard deviation	0.31830089
Coefficient of variation (CV)	1.1078369
Kurtosis	-0.59816749
Mean	0.28731746
Median Absolute Deviation (MAD)	0.1381
Skewness	0.90638062
Sum	48869.539
Variance	0.10131546
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.995	311	0.2%
0.994	293	0.2%
0.993	276	0.2%
0.103	267	0.2%
0.101	256	0.2%
0.11	253	0.1%
0.114	252	0.1%
0.102	249	0.1%
0.119	248	0.1%
0.111	245	0.1%
Other values (4900)	167439	98.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	25	< 0.1%
1.07 × 10^-6	2	< 0.1%
1.08 × 10^-6	1	< 0.1%
1.15 × 10^-6	1	< 0.1%
1.2 × 10^-6	1	< 0.1%
1.23 × 10^-6	1	< 0.1%
1.25 × 10^-6	1	< 0.1%
1.27 × 10^-6	1	< 0.1%
1.28 × 10^-6	1	< 0.1%
1.3 × 10^-6	1	< 0.1%

Value	Count	Frequency (%)
0.996	85	< 0.1%
0.995	311	0.2%
0.994	293	0.2%
0.993	276	0.2%
0.992	236	0.1%
0.991	235	0.1%
0.99	186	0.1%
0.989	167	0.1%
0.988	185	0.1%
0.987	180	0.1%

instrumentalness
Real number (ℝ)

Distinct	5399
Distinct (%)	3.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.12418812

Minimum	0
Maximum	0.999
Zeros	58312
Zeros (%)	34.3%
Negative	0
Negative (%)	0.0%
Memory size	1.3 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	3.73 × 10^-5
Q3	0.0203
95-th percentile	0.876
Maximum	0.999
Range	0.999
Interquartile range (IQR)	0.0203

Descriptive statistics

Standard deviation	0.2749173
Coefficient of variation (CV)	2.2137165
Kurtosis	2.826495
Mean	0.12418812
Median Absolute Deviation (MAD)	3.73 × 10^-5
Skewness	2.1079729
Sum	21123.034
Variance	0.075579519
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	58312	34.3%
0.926	134	0.1%
0.911	132	0.1%
0.899	124	0.1%
0.906	124	0.1%
0.912	121	0.1%
0.905	120	0.1%
0.917	119	0.1%
0.91	117	0.1%
0.89	115	0.1%
Other values (5389)	110671	65.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	58312	34.3%
1 × 10^-6	27	< 0.1%
1.01 × 10^-6	59	< 0.1%
1.02 × 10^-6	74	< 0.1%
1.03 × 10^-6	75	< 0.1%
1.04 × 10^-6	70	< 0.1%
1.05 × 10^-6	71	< 0.1%
1.06 × 10^-6	71	< 0.1%
1.07 × 10^-6	62	< 0.1%
1.08 × 10^-6	65	< 0.1%

Value	Count	Frequency (%)
0.999	2	< 0.1%
0.998	2	< 0.1%
0.997	1	< 0.1%
0.996	1	< 0.1%
0.995	1	< 0.1%
0.994	5	< 0.1%
0.993	8	< 0.1%
0.992	4	< 0.1%
0.991	1	< 0.1%
0.99	2	< 0.1%

liveness
Real number (ℝ)

Distinct	1749
Distinct (%)	1.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.20091219

Minimum	0
Maximum	1
Zeros	41
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	1.3 MiB

Quantile statistics

Minimum	0
5-th percentile	0.05994
Q1	0.096
median	0.127
Q3	0.255
95-th percentile	0.608
Maximum	1
Range	1
Interquartile range (IQR)	0.159

Descriptive statistics

Standard deviation	0.17528637
Coefficient of variation (CV)	0.87245266
Kurtosis	5.2629844
Mean	0.20091219
Median Absolute Deviation (MAD)	0.0469
Skewness	2.2168695
Sum	34172.953
Variance	0.030725312
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.111	2023	1.2%
0.11	1856	1.1%
0.108	1760	1.0%
0.109	1710	1.0%
0.107	1707	1.0%
0.105	1649	1.0%
0.106	1638	1.0%
0.112	1610	0.9%
0.103	1609	0.9%
0.104	1571	0.9%
Other values (1739)	152956	89.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	41	< 0.1%
0.00673	1	< 0.1%
0.00936	1	< 0.1%
0.0102	1	< 0.1%
0.0109	1	< 0.1%
0.0116	1	< 0.1%
0.0118	1	< 0.1%
0.0119	1	< 0.1%
0.012	1	< 0.1%
0.0121	2	< 0.1%

Value	Count	Frequency (%)
1	3	< 0.1%
0.999	2	< 0.1%
0.998	5	< 0.1%
0.997	3	< 0.1%
0.996	7	< 0.1%
0.995	7	< 0.1%
0.994	5	< 0.1%
0.993	10	< 0.1%
0.992	12	< 0.1%
0.991	11	< 0.1%

valence
Real number (ℝ)

Distinct	1680
Distinct (%)	1.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.47289893

Minimum	0
Maximum	1
Zeros	111
Zeros (%)	0.1%
Negative	0
Negative (%)	0.0%
Memory size	1.3 MiB

Quantile statistics

Minimum	0
5-th percentile	0.0798
Q1	0.265
median	0.46
Q3	0.674
95-th percentile	0.906
Maximum	1
Range	1
Interquartile range (IQR)	0.409

Descriptive statistics

Standard deviation	0.25366017
Coefficient of variation (CV)	0.53639403
Kurtosis	-0.98871747
Mean	0.47289893
Median Absolute Deviation (MAD)	0.204
Skewness	0.15131354
Sum	80434.907
Variance	0.06434348
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.961	415	0.2%
0.962	321	0.2%
0.963	319	0.2%
0.964	289	0.2%
0.357	271	0.2%
0.96	269	0.2%
0.336	266	0.2%
0.33	264	0.2%
0.524	262	0.2%
0.398	258	0.2%
Other values (1670)	167155	98.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	111	0.1%
1 × 10^-5	14	< 0.1%
0.00122	1	< 0.1%
0.00392	1	< 0.1%
0.00485	1	< 0.1%
0.00553	1	< 0.1%
0.00602	1	< 0.1%
0.00847	1	< 0.1%
0.00984	1	< 0.1%
0.0115	1	< 0.1%

Value	Count	Frequency (%)
1	4	< 0.1%
0.998	1	< 0.1%
0.997	1	< 0.1%
0.995	3	< 0.1%
0.993	1	< 0.1%
0.992	1	< 0.1%
0.991	2	< 0.1%
0.99	4	< 0.1%
0.989	2	< 0.1%
0.988	6	< 0.1%

tempo
Real number (ℝ)

Distinct	71241
Distinct (%)	41.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	121.14205

Minimum	0
Maximum	235.781
Zeros	97
Zeros (%)	0.1%
Negative	0
Negative (%)	0.0%
Memory size	1.3 MiB

Quantile statistics

Minimum	0
5-th percentile	77.691
Q1	98.007
median	120.133
Q3	139.948
95-th percentile	174.2446
Maximum	235.781
Range	235.781
Interquartile range (IQR)	41.941

Descriptive statistics

Standard deviation	29.39296
Coefficient of variation (CV)	0.24263218
Kurtosis	-0.17777247
Mean	121.14205
Median Absolute Deviation (MAD)	20.155
Skewness	0.32054288
Sum	20604930
Variance	863.94607
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	97	0.1%
128.001	76	< 0.1%
127.998	70	< 0.1%
128.013	69	< 0.1%
127.997	67	< 0.1%
128	66	< 0.1%
127.999	64	< 0.1%
127.992	64	< 0.1%
128.002	62	< 0.1%
119.994	61	< 0.1%
Other values (71231)	169393	99.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	97	0.1%
31.167	1	< 0.1%
31.988	1	< 0.1%
32.055	1	< 0.1%
32.724	1	< 0.1%
34.082	1	< 0.1%
34.782	1	< 0.1%
34.821	1	< 0.1%
35.204	1	< 0.1%
35.37	1	< 0.1%

Value	Count	Frequency (%)
235.781	1	< 0.1%
232.08	1	< 0.1%
226.705	1	< 0.1%
220.251	1	< 0.1%
220.169	1	< 0.1%
220.16	1	< 0.1%
220.092	1	< 0.1%
219.918	1	< 0.1%
219.785	1	< 0.1%
219.364	1	< 0.1%

uri
Categorical

HIGH CARDINALITY UNIFORM UNIQUE

Distinct	170089
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Memory size	1.3 MiB

spotify:track:0UaMYEvWZi0ZqiDOoHU3YI	1
spotify:track:7hU88dWKOrWmfLk0HhQvSV	1
spotify:track:1ABGVrP1QEzjMPfzM0KXKt	1
spotify:track:7jJQzk7Ng6wjc8jk04xXNF	1
spotify:track:5XagNVHf4diy4zeM5p0VZc	1
Other values (170084)	170084

Length

Max length	36
Median length	36
Mean length	36
Min length	36

Characters and Unicode

Total characters	6123204
Distinct characters	63
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	170089 ?
Unique (%)	100.0%

Sample

1st row	spotify:track:0UaMYEvWZi0ZqiDOoHU3YI
2nd row	spotify:track:6I9VzXrHxO9rA9A5euc8Ak
3rd row	spotify:track:0WqIKmW4BTrj3eJFmnCKMv
4th row	spotify:track:1AWQoqb9bSvzTjaLralEkT
5th row	spotify:track:1lzr43nnXAijIGYnCT8M8H

Common Values

Value	Count	Frequency (%)
spotify:track:0UaMYEvWZi0ZqiDOoHU3YI	1	< 0.1%
spotify:track:7hU88dWKOrWmfLk0HhQvSV	1	< 0.1%
spotify:track:1ABGVrP1QEzjMPfzM0KXKt	1	< 0.1%
spotify:track:7jJQzk7Ng6wjc8jk04xXNF	1	< 0.1%
spotify:track:5XagNVHf4diy4zeM5p0VZc	1	< 0.1%
spotify:track:2qigyAuvoKtaZZKsnynMFT	1	< 0.1%
spotify:track:4e3p8QsYgeMf8eOUwZEIOx	1	< 0.1%
spotify:track:1x4AHWj90fpKObG5URZr9g	1	< 0.1%
spotify:track:6QFgpUiLoXlmYDjbe0tjyP	1	< 0.1%
spotify:track:72UnWvJ8X67nAzjaHNamYr	1	< 0.1%
Other values (170079)	170079	> 99.9%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
spotify:track:0uamyevwzi0zqidoohu3yi	1	< 0.1%
spotify:track:12qzhaeoytf93yawvgdtat	1	< 0.1%
spotify:track:215jyyyunrj98nk3kewu6d	1	< 0.1%
spotify:track:4bp3uh0hflfrb5cjsglqdh	1	< 0.1%
spotify:track:4pmc2axseq6g7hpvljcpyp	1	< 0.1%
spotify:track:0wqikmw4btrj3ejfmnckmv	1	< 0.1%
spotify:track:1awqoqb9bsvztjalralekt	1	< 0.1%
spotify:track:1lzr43nnxaijigynct8m8h	1	< 0.1%
spotify:track:0xufyu2qvipas6bxspxyg4	1	< 0.1%
spotify:track:68vgtrhr7izhpzgpon6jlo	1	< 0.1%
Other values (170079)	170079	> 99.9%

Most occurring characters

Value	Count	Frequency (%)
t	397686	6.5%
:	340178	5.6%
p	228160	3.7%
r	227844	3.7%
f	227806	3.7%
c	227786	3.7%
i	227765	3.7%
y	227759	3.7%
a	227741	3.7%
k	227623	3.7%
Other values (53)	3562856	58.2%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	3539883	57.8%
Uppercase Letter	1496102	24.4%
Decimal Number	747041	12.2%
Other Punctuation	340178	5.6%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
t	397686	11.2%
p	228160	6.4%
r	227844	6.4%
f	227806	6.4%
c	227786	6.4%
i	227765	6.4%
y	227759	6.4%
a	227741	6.4%
k	227623	6.4%
s	227541	6.4%
Other values (16)	1092172	30.9%

Uppercase Letter

Value	Count	Frequency (%)
F	58043	3.9%
D	58019	3.9%
I	57910	3.9%
B	57882	3.9%
E	57799	3.9%
L	57754	3.9%
A	57717	3.9%
Q	57709	3.9%
J	57689	3.9%
S	57665	3.9%
Other values (16)	917915	61.4%

Decimal Number

Value	Count	Frequency (%)
0	79780	10.7%
6	79735	10.7%
1	79703	10.7%
5	79545	10.6%
4	79545	10.6%
3	79365	10.6%
2	79161	10.6%
7	74927	10.0%
9	57682	7.7%
8	57598	7.7%

Other Punctuation

Value	Count	Frequency (%)
:	340178	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	5035985	82.2%
Common	1087219	17.8%

Most frequent character per script

Latin

Value	Count	Frequency (%)
t	397686	7.9%
p	228160	4.5%
r	227844	4.5%
f	227806	4.5%
c	227786	4.5%
i	227765	4.5%
y	227759	4.5%
a	227741	4.5%
k	227623	4.5%
s	227541	4.5%
Other values (42)	2588274	51.4%

Common

Value	Count	Frequency (%)
:	340178	31.3%
0	79780	7.3%
6	79735	7.3%
1	79703	7.3%
5	79545	7.3%
4	79545	7.3%
3	79365	7.3%
2	79161	7.3%
7	74927	6.9%
9	57682	5.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	6123204	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
t	397686	6.5%
:	340178	5.6%
p	228160	3.7%
r	227844	3.7%
f	227806	3.7%
c	227786	3.7%
i	227765	3.7%
y	227759	3.7%
a	227741	3.7%
k	227623	3.7%
Other values (53)	3562856	58.2%

duration_ms
Real number (ℝ)

Distinct	65472
Distinct (%)	38.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	238712.33

Minimum	3056
Maximum	5279768
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.3 MiB

Quantile statistics

Minimum	3056
5-th percentile	136000
Q1	192867
median	225432
Q3	266840
95-th percentile	376320
Maximum	5279768
Range	5276712
Interquartile range (IQR)	73973

Descriptive statistics

Standard deviation	100754
Coefficient of variation (CV)	0.42207288
Kurtosis	381.35906
Mean	238712.33
Median Absolute Deviation (MAD)	36139
Skewness	11.827945
Sum	4.0602341 × 10¹⁰
Variance	1.0151368 × 10¹⁰
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
240000	138	0.1%
192000	88	0.1%
180000	85	< 0.1%
210000	70	< 0.1%
216000	70	< 0.1%
204000	64	< 0.1%
228000	58	< 0.1%
200000	57	< 0.1%
220000	56	< 0.1%
270000	54	< 0.1%
Other values (65462)	169349	99.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
3056	9	< 0.1%
4000	1	< 0.1%
4107	1	< 0.1%
4227	1	< 0.1%
4520	1	< 0.1%
4800	1	< 0.1%
4876	1	< 0.1%
5227	1	< 0.1%
5471	1	< 0.1%
5887	1	< 0.1%

Value	Count	Frequency (%)
5279768	1	< 0.1%
5062000	1	< 0.1%
4788939	1	< 0.1%
4556388	1	< 0.1%
4500037	1	< 0.1%
4497994	1	< 0.1%
4436000	1	< 0.1%
4316155	1	< 0.1%
4276000	1	< 0.1%
4120258	1	< 0.1%

Auto

Heatmap
Table

	danceability	energy	key	loudness	speechiness	acousticness	instrumentalness	liveness	valence	tempo	duration_ms	mode
danceability	1.000	0.107	0.029	0.132	0.243	-0.113	-0.164	-0.108	0.478	-0.088	-0.060	0.093
energy	0.107	1.000	0.033	0.780	0.317	-0.677	-0.106	0.172	0.325	0.200	0.009	0.080
key	0.029	0.033	1.000	0.018	0.041	-0.028	-0.003	0.001	0.041	0.003	0.006	0.250
loudness	0.132	0.780	0.018	1.000	0.214	-0.553	-0.298	0.118	0.242	0.161	-0.036	0.049
speechiness	0.243	0.317	0.041	0.214	1.000	-0.205	-0.174	0.101	0.170	0.083	-0.070	0.095
acousticness	-0.113	-0.677	-0.028	-0.553	-0.205	1.000	0.019	-0.084	-0.125	-0.190	-0.089	0.085
instrumentalness	-0.164	-0.106	-0.003	-0.298	-0.174	0.019	1.000	-0.085	-0.234	-0.007	0.143	0.053
liveness	-0.108	0.172	0.001	0.118	0.101	-0.084	-0.085	1.000	0.005	0.026	-0.031	0.028
valence	0.478	0.325	0.041	0.242	0.170	-0.125	-0.234	0.005	1.000	0.051	-0.190	0.027
tempo	-0.088	0.200	0.003	0.161	0.083	-0.190	-0.007	0.026	0.051	1.000	0.003	0.039
duration_ms	-0.060	0.009	0.006	-0.036	-0.070	-0.089	0.143	-0.031	-0.190	0.003	1.000	0.000
mode	0.093	0.080	0.250	0.049	0.095	0.085	0.053	0.028	0.027	0.039	0.000	1.000

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows
Last rows

	danceability	energy	key	loudness	mode	speechiness	acousticness	instrumentalness	liveness	valence	tempo	uri	duration_ms
0	0.904	0.813	4	-7.105	0	0.1210	0.03110	0.006970	0.0471	0.810	125.461	spotify:track:0UaMYEvWZi0ZqiDOoHU3YI	226864
1	0.774	0.838	5	-3.914	0	0.1140	0.02490	0.025000	0.2420	0.924	143.040	spotify:track:6I9VzXrHxO9rA9A5euc8Ak	198800
2	0.664	0.758	2	-6.583	0	0.2100	0.00238	0.000000	0.0598	0.701	99.259	spotify:track:0WqIKmW4BTrj3eJFmnCKMv	235933
3	0.892	0.714	4	-6.055	0	0.1410	0.20100	0.000234	0.0521	0.817	100.972	spotify:track:1AWQoqb9bSvzTjaLralEkT	267267
4	0.853	0.606	0	-4.596	1	0.0713	0.05610	0.000000	0.3130	0.654	94.759	spotify:track:1lzr43nnXAijIGYnCT8M8H	227600
5	0.881	0.788	2	-4.669	1	0.1680	0.02120	0.000000	0.0377	0.592	104.997	spotify:track:0XUfyU2QviPAs6bxSpXYG4	250373
6	0.662	0.507	5	-8.238	1	0.1180	0.25700	0.000000	0.0465	0.676	86.412	spotify:track:68vgtRHr7iZHpzGpon6Jlo	223440
7	0.570	0.821	2	-4.380	1	0.2670	0.17800	0.000000	0.2890	0.408	210.857	spotify:track:3BxWKCI06eQ5Od8TY2JBeA	225560
8	0.713	0.678	5	-3.525	0	0.1020	0.27300	0.000000	0.1490	0.734	138.009	spotify:track:7H6ev70Weq6DdpZyyTmUXk	271333
9	0.727	0.974	4	-2.261	0	0.0664	0.10300	0.000532	0.1740	0.965	79.526	spotify:track:2PpruBYCo4H7WOBJ7Q2EwM	235213

	danceability	energy	key	loudness	mode	speechiness	acousticness	instrumentalness	liveness	valence	tempo	uri	duration_ms
170079	0.358	0.963	7	-3.725	1	0.1040	0.013600	0.000363	0.3470	0.105	157.450	spotify:track:0l6uRRIDPNw3OsmqCYkmvi	328400
170080	0.443	0.911	9	-4.208	0	0.0851	0.012400	0.000000	0.2780	0.680	160.152	spotify:track:642Zd1NC6fLzbLhjQ8ykcZ	90375
170081	0.542	0.981	2	-2.966	0	0.0779	0.000129	0.000030	0.1440	0.451	139.958	spotify:track:2aFVXUcOs57iVKYM0if4S4	154286
170082	0.739	0.521	3	-5.479	0	0.0707	0.164000	0.000089	0.4320	0.812	99.993	spotify:track:2AbwQmeiU43d4eIe2DkpYr	207000
170083	0.685	0.536	11	-11.036	0	0.1130	0.678000	0.000000	0.1930	0.758	66.329	spotify:track:5LnFmGMIGaIx4WoGFNWz33	135609
170084	0.551	0.822	11	-7.018	0	0.0614	0.001540	0.000000	0.2150	0.360	127.043	spotify:track:4cKPzfOUIZWXhu3GDnESjL	265039
170085	0.480	0.761	6	-4.628	1	0.0367	0.120000	0.000000	0.2960	0.359	160.020	spotify:track:0VICzaRdctD8XGfDstBjQY	368767
170086	0.402	0.767	11	-6.718	0	0.1710	0.000077	0.000003	0.3930	0.558	178.293	spotify:track:0B4YuevrDNhh71edZrFiOs	179267
170087	0.678	0.826	0	-4.742	0	0.0591	0.005240	0.000000	0.0951	0.706	139.989	spotify:track:7i9q0VPbENCoYnJUsJhX9d	242347
170088	0.670	0.483	9	-7.124	0	0.1250	0.213000	0.000000	0.0550	0.770	170.115	spotify:track:6uaJuze0LunPtcbCu1JNtq	169390

Overview

Variables

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Decimal Number

Other Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Interactions

Correlations

Missing values

Sample